object Form1: TForm1
  Left = 193
  Top = 130
  Width = 928
  Height = 480
  Caption = 'Form1'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 0
    Top = 0
    Width = 361
    Height = 442
    Align = alLeft
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'py_code'
        Title.Caption = #33647#21697#32534#30721
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'pack_sn'
        Title.Caption = #21253#35013#24207#21495
        Width = 61
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'spec'
        Title.Caption = #33647#21697#35268#26684
        Width = 62
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'prim_name'
        Title.Caption = #33647#21697#21517#31216
        Visible = True
      end>
  end
  object DBGrid2: TDBGrid
    Left = 546
    Top = 0
    Width = 366
    Height = 442
    Align = alClient
    DataSource = DataSource2
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    OnEnter = DBGrid2Enter
    Columns = <
      item
        Expanded = False
        FieldName = 'yp_code'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'pack_sn'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'prim_name'
        Visible = True
      end>
  end
  object Panel1: TPanel
    Left = 361
    Top = 0
    Width = 185
    Height = 442
    Align = alLeft
    TabOrder = 2
    object Label1: TLabel
      Left = 11
      Top = 72
      Width = 108
      Height = 13
      Caption = #36873#25321#35201#28155#21152#30340#33647#21697#65306
    end
    object Button2: TButton
      Left = 6
      Top = 120
      Width = 75
      Height = 25
      Caption = #28155#21152
      TabOrder = 0
      OnClick = Button2Click
    end
    object Button1: TButton
      Left = 8
      Top = 24
      Width = 97
      Height = 25
      Caption = #35774#32622#25968#25454#36830#25509
      TabOrder = 1
      OnClick = Button1Click
    end
    object tsDBEdit1: TtsDBEdit
      Left = 8
      Top = 92
      Width = 169
      Height = 21
      DataField = 'prim_name'
      DataSource = DataSource3
      TabOrder = 2
      OnDBEditEnter = tsDBEdit1DBEditEnter
      ListField = 'prim_name'
      KeyField = 'yp_code'
      LookUpKeyField = #33647#21697#32534#30721
      LookUpResultField = #33647#21697#21517#31216
      SqlStrings.Strings = (
        'select  a.yp_code as '#33647#21697#32534#30721','
        #9'a.prim_name as '#33647#21697#21517#31216','
        '        a.spec as '#33647#21697#35268#26684','
        #9'a.py_code as '#25340#38899#30721','
        #9'a.wb_code as '#20116#31508#30721','
        '        a.pack_sn as '#21253#35013#24207#21495
        'from yp_base_info a with (nolock)'
        'where a.py_code like :py_code and'
        '      a.wb_code like :wb_code and'
        '      a.yp_code like :code and'
        '      a.prim_name like  '#39'%'#39' + :name and'
        '      CharIndex(a.drug_type,:drug_type) > 0')
      DBGridDropColumnWidth = '60,100,60,60,60,60,'
      LookupParams = <
        item
          DataType = ftString
          Name = #25340#38899#30721
          ParamType = ptInput
          Value = '%'
        end
        item
          DataType = ftString
          Name = #20116#31508#30721
          ParamType = ptInput
          Value = '%'
        end
        item
          DataType = ftString
          Name = #33647#21697#32534#30721
          ParamType = ptInput
          Value = '%'
        end
        item
          DataType = ftString
          Name = #33647#21697#21517#31216
          ParamType = ptInput
          Value = '%'
        end>
      ScrollParams = <
        item
          DataType = ftString
          Name = 'yp_code'
          ParamType = ptInput
        end
        item
          DataType = ftString
          Name = 'drug_type'
          ParamType = ptInput
        end>
      FilterParams = <>
      AutoScroll = True
      DBGridAutoDropDown = False
      ConnectComponent = tsConnect1
      NullValueKey = 27
    end
    object Button3: TButton
      Left = 8
      Top = 152
      Width = 75
      Height = 25
      Caption = #20445#23384
      TabOrder = 3
      OnClick = Button3Click
    end
    object Button4: TButton
      Left = 88
      Top = 120
      Width = 75
      Height = 25
      Caption = #21024#38500
      TabOrder = 4
      OnClick = Button4Click
    end
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select  a.yp_code,'
      #9'a.prim_name,'
      '        a.spec,'
      #9'a.py_code,'
      #9'a.wb_code,'
      '        a.pack_sn'
      'from yp_base_info a')
    Left = 176
    Top = 104
  end
  object DataSetProvider1: TDataSetProvider
    DataSet = ADOQuery1
    Left = 208
    Top = 104
  end
  object ClientDataSet1: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider1'
    Left = 248
    Top = 104
    object ClientDataSet1yp_code: TStringField
      FieldName = 'yp_code'
      Size = 7
    end
    object ClientDataSet1prim_name: TStringField
      FieldName = 'prim_name'
      Size = 80
    end
    object ClientDataSet1spec: TStringField
      FieldName = 'spec'
      Size = 80
    end
    object ClientDataSet1py_code: TStringField
      FieldName = 'py_code'
      Size = 25
    end
    object ClientDataSet1wb_code: TStringField
      FieldName = 'wb_code'
      Size = 25
    end
    object ClientDataSet1pack_sn: TStringField
      FieldName = 'pack_sn'
      Size = 2
    end
  end
  object DataSource1: TDataSource
    DataSet = ClientDataSet1
    Left = 288
    Top = 104
  end
  object ADOConnection1: TADOConnection
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=sql;Persist Security Info=True;User' +
      ' ID=sa;Initial Catalog=kmetyy_his_mz;Data Source=192.168.1.216\s' +
      'ql2008r2'
    KeepConnection = False
    LoginPrompt = False
    Provider = 'SQLOLEDB.1'
    Left = 144
    Top = 104
  end
  object tsConnect1: TtsConnect
    ConnectString = 
      'Provider=SQLOLEDB.1;Password=test123;Persist Security Info=True;' +
      'User ID=his;Initial Catalog=hisdbstzx;Data Source=172.16.0.37'
    SqlTableName = 'sys_sql_list'
    SqlTextFieldName = 'sql_text'
    SqlIDFieldName = 'sql_id'
    Left = 144
    Top = 56
  end
  object ADOQuery2: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select yp_code,'
      '        pack_sn,'
      #9'prim_name'
      'from yp_fy_confirm_after_skin')
    Left = 592
    Top = 120
  end
  object ClientDataSet2: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider2'
    Left = 656
    Top = 120
    object ClientDataSet2yp_code: TStringField
      FieldName = 'yp_code'
      Size = 7
    end
    object ClientDataSet2pack_sn: TStringField
      FieldName = 'pack_sn'
      Size = 2
    end
    object ClientDataSet2prim_name: TStringField
      FieldName = 'prim_name'
      Size = 80
    end
  end
  object DataSetProvider2: TDataSetProvider
    DataSet = ADOQuery2
    Left = 624
    Top = 120
  end
  object DataSource2: TDataSource
    DataSet = ClientDataSet2
    Left = 688
    Top = 120
  end
  object ClientDataSet3: TClientDataSet
    Aggregates = <>
    Params = <>
    Left = 232
    Top = 176
    object StringField1: TStringField
      FieldName = 'yp_code'
      Size = 7
    end
    object StringField2: TStringField
      FieldName = 'prim_name'
      Size = 80
    end
  end
  object DataSource3: TDataSource
    DataSet = ClientDataSet3
    Left = 272
    Top = 176
  end
end
